package dao.v2;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import model.MemberLevelItemVO;
import model.MemberVO;

public interface MemberLevelItemVOMapper {

	MemberVO getCurMemberLevelUpInfo(@Param("level")String level, @Param("history_total_ticket")String history_total_ticket);

	List<MemberLevelItemVO> selectenjoyPrivilege(String level);

	List<MemberLevelItemVO> selectadvancePrivilege(@Param("level")String level, @Param("member_id")String string);

	String getMinRate();

	String getMaxRate();

	String getRateByLevel(String level);

	int compareLevel(@Param("level") String level, @Param("max_level") String max_level);

	List<MemberLevelItemVO> selectLevleList();

	String getMyLevleOrd(String member_id);

	List<MemberLevelItemVO> selectLevleListBySomeField(@Param("id")String id, @Param("member_id")String member_id);

	int getStateBySomeField(@Param("id")String id, @Param("member_id")String member_id);

	String getExpPastLevelOne(String id);

	String getOrdBylevel(String level);



}
